Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerAccount(LE_CTAC) |
RevisionNumber (PK) | The sequential version of a CustomerAccountTermsAndConditions agreement. Used to track different versions of a base document. This can be important where previous versions of a contract are in place along with newer versions. | AI_RVSN_NMB | Number | integer | |
CustomerAccountContractNarrative | A business narrative description of the contract and its terms and conditions. | NA_CT_ACNT_CNTRT | DescriptionNarrative | varchar(4000) | |
EffectiveDate | Date this contract revision is in force. | DC_EF_DT | EffectiveDate | date | |
ExpirationDate | Date this contract revision is no longer in force | DC_EP_DT | ExpirationDate | date | |
StatusCode | Current status of this contract revision. Retailers need to exercise care in assigning status codes. While a contract may be modified prior versions tied to older customer accounts may remain in force. Retailers need to define an appropriate contract life cycle management strategy as part of implementing this entity. | CD_STS_CD | Code2Status | char(2) | |